You can add Grand totals and Sub-totals to the columns and rows in your grid. By default, these columns and rows will be highlighted (formatted) to make them more visible. For Tabular or Matrix Grids, you can toggle this special totals formatting on or off from the Components ribbon. For Matrix Grids, you can also override the Totals formatting with gray backgrounds or bold text and show / hide the Totals styles using the Total Formatting setting in the Formatting panel's Settings page.
Tip: Using the Total Formatting > Gray Background option on the Component ribbon can be useful for quickly identifying your Totals.
- Click here to learn more about totals.
Formatting Panel
Tip: You can access the Formatting Panel using the Formatting Selector, or by clicking Format Visual on the Component ribbon. From there you can select Matrix Grid, the Settings tab, and finally enable or disable Total formatting.
Component Ribbon
You can enable or disable this formatting by toggling the Total Formatting option (red arrow below) from the Component ribbon.
You can also open the Total Formatting drop-down to make the totals bold or make the totals background gray.
Example: Enable and Disable Total Formatting
When enabled, formatting for totals is shown:
When disabled, formatting for totals is hidden. The total columns and rows are still visible, but they don't have any special formatting applied to them:
